B071W3N3CW EBOK by Unknown

Author:Unknown
Language: eng
Format: azw3
Published: 0101-01-01T00:00:00+00:00

As an example, say you want to replace the exact INDEX/MATCH formula shown in figure 27 with an approximate INDEX/MATCH formula.

Figure 27: Example of an approximate INDEX/MATCH

This means that the return column is LookupValues!B:B, the search value is A2, and the search column is LookupValues!A:A. If you put that into the structure of figure 26, you’ll get this formula:

=IF(INDEX(LookupValues!A:A,MATCH(A2,LookupValues!A:A,1))=A2,

INDEX(LookupValues!B:B,MATCH(A2,LookupValues!A:A,1)),

INDEX(LookupValues!B:B,MATCH(A2,LookupValues!A:A,0)))

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.